Skip to main content

Google Sheets Integration

DeliverymanAI allows you to import contacts directly from a Google Sheet.
This integration makes it easy to manage your leads in Google Sheets and sync them into your contact lists without exporting CSV files.

Steps to Import Contacts from Google Sheets​

Prepare Your Google Sheet​

  1. Open Google Sheets.
  2. Select the sheet that contains the contacts you want to import.
  3. Click the Share button in the top-right corner.
  4. Under General access, change the setting to Anyone with the link.
  5. Make sure the permission is set to Viewer.
  6. Copy the sheet link from the browser’s address bar.

This allows DeliverymanAI to access and read the sheet.

Create a Contact List in DeliverymanAI​

  1. Go to Contact Lists in the DeliverymanAI dashboard.
  2. Click Create New Contact List.
  3. Enter a List Name for your contact list.
  4. In the Source dropdown, select Google Sheets.
  5. Paste the copied Google Sheets URL into the field.
  6. Click Validate Sheets Link to verify the connection.

Once the link is validated, DeliverymanAI will read the sheet structure.

DeliverymanAI - Add Domain

Map Your Fields​

After validating the sheet, you will need to map the fields from your Google Sheet to the corresponding fields in DeliverymanAI.

  • Match each column in your Google Sheet to the appropriate field in the platform.

  • Ensure that the Email field is mapped correctly, as this field is required for importing contacts.

  • Map any additional fields such as:

    • First Name
    • Last Name
    • Company
    • Website
    • Custom fields

Once the mapping is complete, proceed with the import.

Import Contacts​

After field mapping is finished:

  1. Click Import.
  2. DeliverymanAI will process the Google Sheet and create the contact list.
  3. Your contacts will then be available for use in campaigns.

Important Notes​

  • Your Google Sheet must have “Anyone with the link” access enabled.
  • The sheet must include a valid Email column, as it is required for sending campaigns.
  • The first row of your sheet should contain column headers.
  • Avoid duplicate or invalid email addresses in the sheet.